1 Background

LinkedIn is an illustrious website that helps professionals connect with one another. It is also a portal for people to display their skills as well as the path that their career has taken through the years. It contains a variety of information ranging from education, knowledge to checkpoints in their career.

Employers also use this platform for recruiting professionals. So it is a useful tool which is slowly becoming a necessity for people entering into the corporate world. Navigation and understanding crucial skills for their profession of choice and the location they would flourish goes a long way in crafting a successful career.

2 Scope

2.1 Information on Data

The World Bank Group - Linkedin Digital Data for Development1 attempts to harness LinkedIn data covering more than 100 countries. For the purpose of this report the following datasets will be accessed:

  • Excel: Industry Skills Needs
  • Excel: Talent Migration
  • Excel: Employment Growth

2.2 Scope of Data

The above excel sheets will be utilized for charting trends based on industry skills, migration of talent across the globe and global employment growth statistics.

3 Rationale

The report will be charting the trends in LinkedIn across all fields. It will be delving into the kind of skills that are gaining or losing popularity across different verticals as well as what the top few must have skills are for all working professionals.

The other useful component for young professionals is what the migration trends are with respect to their skills and which place would give them space to learn and display their potential.

The final aspect but supremely important one is whether the global employment trends are conducive to their growth. Only upon knowing this aspect is it possible for them to decide whether migration is a good option or upskilling is necessary.

4 Research Questions

  • Which skills are gaining or losing popularity according to the data in each vertical?
  • Which are the top few must have skills for all working professionals across the years?
  • What is the global trend of employment growth?
  • How did the employment pattern change in different industries over the years? # Methodology

4.1 Skills

4.1.1 Trend of skill categories across the different verticals by year

In order to analyse the different skill categories by vertical the excel sheet for industry skill needs has to be used. Upon importing this data the below steps must be taken to generate 4.1:

  • Here verticals refers to the different isic sections (within which multiple industries are coalesced)
  • The data of the top 10 skills being utilized within each of these industries is present.
  • These skills are grouped by the number of skills for each category used within industry for each isic section.
  • This gives us a split of the occurrence of the skill group for each section per year.
  • This split is then represented using an animated rose chart for overall comparison as we do not require a quantitave comparison of exact number in this trend.
Trend of skill categories across the different verticals by year

Figure 4.1: Trend of skill categories across the different verticals by year

4.1.2 Trend in change of useful skills across occupations

In order to analyse the top 10 useful skills on LinkedIn by year, the excel sheet for industry skill needs has to be used. Upon importing this data the below steps must be taken to generate 4.2:

  • The data set is grouped by year and skill_group_name variable (which gives the name of the skill)
  • The top 10 for each year are then filtered out and used for simulation of graph.

Figure 4.2: Trend in change of useful skills across occupations

4.2 Talent Migration

4.3 Employment Growth

4.3.1 Global Trend of Employment Growth

To analysis the global trend of employment growth, the growth rate from 2015-2019 was taken to see the rate changed over the years as shown below in Figure 4.3.

Global trend of employment grwoth from 2015-2019

Figure 4.3: Global trend of employment grwoth from 2015-2019

Based on Figure 4.3, it is found that the employment growth rate in high income areas such as the USA, European countries and Australia were slowing down. However, the other income groups had an increasing trend on the growth rate. Further details will be elaborated in the next section.

4.3.2 Trend of employment growth rate in different industries and income groups

In order to analysis the further development of the trend, the growth rate is separated in different income groups and industries as shown in Figure 4.4:

Figure 4.4: Trend of employment growth rate based on industries

Based on Figure 4.4, the high income group had a downwards slope on employment growth rate whereas the other groups had an increasing trends. The reasons are as follow:

  • The low oil price had delayed the interest rate hikes in the high income countries. However, it has brought opportunities to oil importing countries like India and China, which lowered the production cost and increased the competitive of the products produced.2 This slowed down the development in high income countries meanwhile swapped the chances to the other income groups.

  • The political disputes threatened the global growth. For example, the “Trade wars” between China and the USA had brought chaos to the global market which badly affect the global economy. This eventually shrank the employment growth.3

5 Analysis

5.1 Trend of skill categories across the different verticals by year

After examining 4.1, the below highlights were taken note of: - Soft skills are the one set of skills that people have increasingly found need for across all the verticals. - Business skills are finding less and less takers by the year. - Specialized industry skills seem to have seen volatility as they were in decline up until 2017-2018 but with the arrival of 2019 they saw a significant boost in demand. - Disruptive technological skills do not seem to have caught on yet except for the Information and Communication segment. - Mining and Quarrying have seen no disruptive tech skills growth whatsoever. - Despite fintech4 sweeping across the world, among the people employed in the field of financial and insurance activities little to no technical skills seem to be visible.

  • The skill that is the most in demand across all years is Digital Literacy.
  • Business Management, Leadership and Teamwork are also right behind. Business Management however has been in decline since 2017 while Teamwork has taken the forefront.

5.2 Trend in change of useful skills across occupations

After examining 4.2, the below highlights were taken note of:

  • Digital Literacy remains the skill that is the most in demand across every year.
  • Business Management, Leadership and Teamwork take up the next 3 spots.
  • However post 2017, Business management has seen a sharp decline in terms of importance while Leadership and Teamwork are becoming increasingly crucial.
Table 5.1: Split of the skill groups the top skills belong to between 2015-2019
Category of Skill Number of times it occurs in top 10
Business Skills 5
Soft Skills 4
Specialized Industry Skills 2
Tech Skills 3
  • From the table 5.1 Business Skills - 5, Soft Skills - 4, Business Skills - 2, Soft Skills - 3 are the split across the top 2 type of skills. Business skills and Soft skills still dominate.
  • Specialized Industry skills figure in this list too.
  • These are Research and Foreign Languages. In an increasingly interconnected world, it is quite evident why Foreign Languages make this list.
  • Research also forms the corner stone of innovation and is an important skill to possess.
  • Apart from this, Social media is also a technological main stay which figures prominently. This is yet another proof of the influence of technology on skills needed.

5.3 Trend in employment rate

5.3.1 Employment growth

Table 5.2: Top 5 employment growth industries
Industry Name Average Persentage of Growth
Venture Capital & Private Equity 3.584088
Alternative Dispute Resolution 2.462249
Computer & Network Security 2.097874
Renewables & Environment 2.069448
Aviation & Aerospace 1.673296

Based on Table 5.2, it is found that venture capital & private equity industry, which catalyzed technological innovation, had the highest average growth between 2015-2019. The possible reason is that the new rapid boom in information technology industry required great amount of capital investment, which boost the growth in these industries.

5.3.2 Employment recession

Table 5.3: Top 5 employment recession industries
Industry Name Average Percentage of Growth
Newspapers -2.103078
Accounting -2.074900
Market Research -1.822482
Outsourcing/Offshoring -1.798203
Telecommunications -1.538015

According to Table 5.3, the traditional media like newspapers, telecommunications,etc had the higher recession from 2015-2019. It is because of the great boom in social media and social network. People tend to watch the news online and communicate on social media apps which had shrank the development in traditional media.

6 Conclusions

Professionals in today’s day and time are always looking for opportunities to grow in terms of their career. There are multiple aspects to this growth and the environment needed to enrich the growth.

Skills are front and center in terms of must-haves for a fruitful career. From the analysis it is clear that soft skills are a necessity regardless of vertical. Business skills have no longer remained the mainstay that they used to be and tech skills are here to stay however their disruptiveness in every sector is up for debate.

As one chooses to upskill, they find it harder to stay stationary within their old environment and migrate to greener pastures. From above trends it is observed that hard skills like Data Driven Analytics, Fintech, Nanotechnology and soft skills like Persuasion has seen an upward trend in terms of skill gain due to migration. This can be credited to expanding technology and the growing stock markets and startup culture looking at the Venture Capital and Private Equity industry trend.

However we also need to consider whether the current economy is at the state where such activities are possible and employment growth would directly relate to whether the upskilling has to do with retaining jobs or switching them out. The Information and communication sector has a rapid boom in recent years which indicates that there are larger demand of labor whereas the recession in traditional media and communications sectors cause more and more labor being laid off.

7 Recommendations

  • Professionals need to upskill in non conventional fields like social media to remain up to date.
  • Digital literacy is an important must have for this day and age.
  • Business skills and soft skills are a necessity as well for people in all fields.
  • Try to look for jobs in financial and information technology industries, avoid to look for the jobs in traditional media industry.

8 Limitations

  • Currently the weight of the different skills according to ranking has been disregarded so some level of depth is lost in terms of importance.
  • The employment growth rate is observed in global trend, it may not be accurate when it came to specific local analysis.

9 Bibliography

Wickham et al. (2019) Sievert (2020) Zhu (2021) South (2017) Garnier (2018) Pebesma (2018) Neuwirth (2014) Bivand and Rundel (2020) Wickham and Bryan (2019) Pedersen and Robinson (2020) Slowikowski (2021) South (2011) Xie (2021) worldbank (2015) UN (2019)

Agarrwal, K. 2021. What Is Fintech? forbes. https://www.forbes.com/advisor/in/banking/what-is-fintech/.

Bivand, Roger, and Colin Rundel. 2020. Rgeos: Interface to Geometry Engine - Open Source (’Geos’). https://CRAN.R-project.org/package=rgeos.

Garnier, Simon. 2018. Viridis: Default Color Maps from ’Matplotlib’. https://CRAN.R-project.org/package=viridis.

Industry Jobs and Skills Trends. n.d. World Bank Group - LinkedIn. (n.d.). World Bank LinkedIn Digital Data for Development. https://linkedindata.worldbank.org.

Neuwirth, Erich. 2014. RColorBrewer: ColorBrewer Palettes. https://CRAN.R-project.org/package=RColorBrewer.

Pebesma, Edzer. 2018. “Simple Features for R: Standardized Support for Spatial Vector Data.” The R Journal 10 (1): 439–46. https://doi.org/10.32614/RJ-2018-009.

Pedersen, Thomas Lin, and David Robinson. 2020. Gganimate: A Grammar of Animated Graphics. https://CRAN.R-project.org/package=gganimate.

Sievert, Carson. 2020. Interactive Web-Based Data Visualization with R, Plotly, and Shiny. Chapman; Hall/CRC. https://plotly-r.com.

Slowikowski, Kamil. 2021. Ggrepel: Automatically Position Non-Overlapping Text Labels with ’Ggplot2’. https://CRAN.R-project.org/package=ggrepel.

South, Andy. 2011. “Rworldmap: A New R Package for Mapping Global Data.” The R Journal 3 (1): 35–43. http://journal.r-project.org/archive/2011-1/RJournal_2011-1_South.pdf.

———. 2017. Rnaturalearth: World Map Data from Natural Earth. https://CRAN.R-project.org/package=rnaturalearth.

UN. 2019. World Economic Situation and Prospects: September 2019 Briefing, No. 130. UN. https://www.un.org/development/desa/dpad/publication/world-economic-situation-and-prospects-september-2019-briefing-no-130/.

Wickham, Hadley, Mara Averick, Jennifer Bryan, Winston Chang, Lucy D’Agostino McGowan, Romain François, Garrett Grolemund, et al. 2019. “Welcome to the tidyverse.” Journal of Open Source Software 4 (43): 1686. https://doi.org/10.21105/joss.01686.

Wickham, Hadley, and Jennifer Bryan. 2019. Readxl: Read Excel Files. https://CRAN.R-project.org/package=readxl.

worldbank. 2015. Global Economic Prospects to Improve in 2015, but Divergent Trends Pose Downside Risks, Says Wb. worldbank. https://www.worldbank.org/en/news/press-release/2015/01/13/global-economic-prospects-improve-2015-divergent-trends-pose-downside-risks.

Xie, Yihui. 2021. Bookdown: Authoring Books and Technical Documents with R Markdown. https://github.com/rstudio/bookdown.

Zhu, Hao. 2021. KableExtra: Construct Complex Table with ’Kable’ and Pipe Syntax. https://CRAN.R-project.org/package=kableExtra.

  1. (Industry Jobs and Skills Trends, n.d.)↩︎

  2. worldbank (2015)↩︎

  3. UN (2019)↩︎

  4. Agarrwal (2021)↩︎